SQL Editor - Build Query - Show Tables

Selecting Show Tables lists all of the tables (and views) available from the database associated with the DataBlock.

Show Table Toolbar

Button Description
Group by Catalog button Arrange the table list based on the catalog.
Group by Schema button Arrange the table list based on the schema.
Group by Table Type button Arrange the table list based on the type of table.
Group Alphabetically button Arrange the table list based on the first letter of the table name.
Refresh button Refresh the table list.
Add Table button Add the currently selected table to the query.
Search button View extended properties for the currently selected table.

 

Build Query dialog with the Show Tables option selected.   All database tables are listed and can be selected to be included in the query.

 

See also: